Bank Personal Loan Analysis

Data description

Visualize distribution of the data

array([[<matplotlib.axes._subplots.AxesSubplot object at 0x7fe3966dc1d0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394abbf90>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394b32c50>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394f58fd0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394f8dc90>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe3966824d0>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394d70cd0>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394ca6510>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe394cb2090>],
       [<matplotlib.axes._subplots.AxesSubplot object at 0x7fe394c30a10>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe3934d6d50>,
        <matplotlib.axes._subplots.AxesSubplot object at 0x7fe393784590>]],
      dtype=object)

<matplotlib.axes._subplots.AxesSubplot at 0x7fe396707990>

<matplotlib.axes._subplots.AxesSubplot at 0x7fe37718ec90>

There are 624 records which has negative values for experience, appox1.04 %

Correlation of data

<matplotlib.axes._subplots.AxesSubplot at 0x7fe393645e50>

Analyze Education Status of customer

Explore the account holder distribution

	Age	Income	Family	CCAvg	Education	Mortgage	Personal Loan	Securities Account	CD Account	Online	CreditCard	Edu_mark	Account_holder_category
0	25	49	4	1.6	1	0	0	1	0	0	0	Undergrad	Holds only securities
1	45	34	3	1.5	1	0	0	1	0	0	0	Undergrad	Holds only securities
2	39	11	1	1.0	1	0	0	0	0	0	0	Undergrad	Does not Holds securities or Deposit
3	35	100	1	2.7	2	0	0	0	0	0	0	Graduate	Does not Holds securities or Deposit
4	35	45	4	1.0	2	0	0	0	0	0	1	Graduate	Does not Holds securities or Deposit

Does not Holds securities or Deposit    4323
Holds only securities                    375
Holds only Deposit                       155
Holds securities & Deposit               147
Name: Account_holder_category, dtype: int64

Analyze customer on the basis of their education status, income and personal loan status

<matplotlib.axes._subplots.AxesSubplot at 0x7fe3939b6690>

<matplotlib.legend.Legend at 0x7fe377933290>

Analyze categories of customers on the basis of Security account, Online, Account_holder category & credit card

How age of a person is going to be a factor in available loan?

<matplotlib.axes._subplots.AxesSubplot at 0x7fe378cc8cd0>

Age does not have impact on availing personal loan as the p_value is greater than 0.05 with a value of 0.584959263705325

Does income of a person have an impact on availing loan?

Income does have impact on availing personal loan, as the p_value is less than 0.05 with a value of 0.0

Does the family size makes them to avail loan?

Family does have impact on availing personal loan, as the p_value is less than 0.05 with a value of 1.4099040685673807e-05

[NbConvertApp] Converting notebook Finance_to_html.ipynb to html
[NbConvertApp] Writing 4623587 bytes to Finance_to_html.html